Use the Generative AI Integration to generate PQL or MDX code. This is useful if you want to generate code quickly, or aren't sure about the syntax, for instance. To do this, click Script Mode > AI Formula from the ribbon. In the text field at the top of the Generate Your PQL dialog (or Generate Your MDX dialog for MS OLAP, Tabular, and BW models), enter a description of the query you want to perform.
- Text Field: enter a description of the query you want to perform and click the arrow to enter your query description and return a it as a script. (red highlight below).
- Schemas: the schemas panel exposes the database schema (orange highlight below); you can select the dimensions, elements, and views that are relevant to your description to simplify the query,
- Script Window: the AI-generated script will appear in the scripting window (green highlight below).
- Apply: apply the script to the Query node.
- Cancel: close the dialog without applying any changes.
AI-generated scripting is supported in:
Warning: AI-generated assets are generated from public domain algorithms, which can produce both erroneous and inconsistent or random results. Use at your own risk.